SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324608 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324608 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154197,86709,890809,377736,19551,388683,410535,605175,312695,562183,271739,354182,111467,513487,922972,86913,486783,10107,1023663,127367,169438,1042848,588781,188294,343272,690071,446971,508419,253181,390664,651103,786992,619158,831674,516949,820536,28806,732483,810347,823327,449795,301756,421721,312835,481397,933965,268795,888674,892282,218718,321970,306141,13797,412172,241981,359354,921209,835971,224758,234624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]