SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55682 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55682 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258859,485360,185001,472420,822689,142830,973958,784979,37153,1032263,460357,732622,105257,265549,559263,584940,1036401,368789,463003,268512,906365,60004,193433,141683,408648,405766,630618,192666,951988,317780,13013,747029,716684,418956,444102,96646,979090,599840,142363,295741,31987,424341,772176,9239,403577,829034,307703,992365,801942,817147,521427,1408,1046233,244496,890000,307901,335979,587300,773742,371098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001166s ]