SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533931 LIMIT 1 [ RunTime:0.001988s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533931 [ RunTime:0.006133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560221,39628,770285,575402,150037,379110,249965,382105,902233,331903,968839,725760,375617,847943,256835,835201,617093,733685,179330,81111,418009,770640,785973,193473,572717,259783,812651,858393,893723,749991,315753,213769,390472,781314,343653,667123,460898,305106,577796,808102,832434,249229,692261,438157,897511,179758,71604,816695,36239,967589,354505,799128,19877,283265,147587,702389,1032689,221389,461713,89699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]