SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103146 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103146 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037540,539726,119974,444067,909425,177328,458696,595427,32784,662197,684218,315556,850171,296241,541122,1046097,392176,802898,270786,340334,460851,2452,637717,823241,110367,533710,200861,348955,729783,159439,921747,403319,743089,235923,950428,582121,582642,267878,298695,52559,139408,181457,218405,658105,988721,492786,171382,984555,795918,501780,76103,524628,810038,319344,205960,42978,1016845,363463,708144,425032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]