SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550047 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550047 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194116,88980,148162,547615,665756,1005308,549190,124077,546989,650118,347264,194414,599440,492682,861888,116538,205871,2174,930595,293791,400288,160343,984666,739849,961626,706534,774153,400625,116689,289583,26198,290809,723736,303579,683175,341076,1028107,428546,147063,634330,338437,961843,548498,844463,522397,189752,273165,917827,843133,977093,307363,99649,718692,957626,295591,514151,267492,598750,441324,264694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]