SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340171 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340171 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98636,429982,813788,281343,97513,735410,672618,750133,34081,523230,884242,754918,1040505,247705,717573,138558,409112,979394,49356,79189,573485,391962,587735,778509,409438,551957,62919,384459,442526,857820,628167,992753,401514,438120,401001,1031803,353574,302884,731133,578653,302105,156149,380668,510114,812036,952966,580935,160156,228453,169844,23719,840360,980834,695104,310512,33580,837728,930992,1033980,698759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001927s ]