SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 989241 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 989241 [ RunTime:0.002016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71862,141940,770998,382344,384854,1021393,561081,152982,132158,1005232,243944,411038,824499,612770,326431,332710,295431,758706,657114,342169,734653,699972,1032782,1015898,530180,902892,1041388,741322,12054,787384,914539,34791,961809,790609,1008035,559686,803747,328938,759457,849981,15834,876922,263014,591006,612995,639877,260930,987234,807694,723894,439965,328012,539290,513061,825288,546320,185482,331210,385390,132488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 989241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 989241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]