SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392258 LIMIT 1 [ RunTime:0.003332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392258 [ RunTime:0.002977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50466,660230,299493,227688,261650,1014736,689575,542560,494963,151513,1031313,989600,798565,459280,26440,841693,945229,521109,433366,506729,400644,87718,1026689,484594,554906,866381,273540,314455,717417,384543,989142,700297,1043075,269206,1165,400266,186498,96517,298256,805525,1025484,174648,787392,548833,147882,99031,37298,697156,536734,453175,634829,877137,489779,343953,55899,389446,1047614,835697,949573,246201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000826s ]