SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196004 LIMIT 1 [ RunTime:0.000648s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196004 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656580,922732,243839,207983,236418,107410,268128,296928,387414,556688,27301,745248,818801,989970,972827,695186,130261,1039831,320832,514076,889659,957118,572862,844661,87352,545467,934268,867254,393106,848608,801253,747141,1009661,321871,315098,167722,704494,107551,294478,195508,1003697,510204,309703,421661,542433,346511,357960,460770,212654,790563,214459,763447,99442,552673,402609,526611,892463,825757,1039609,572224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]