SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412075 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412075 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525922,105425,283481,243765,213908,1008899,417700,53095,78823,367824,463745,47076,437142,440769,75416,409286,414388,887885,461682,697537,819955,180698,186355,1015251,250538,424884,183216,267243,875601,166215,965149,813374,563632,15777,966869,187622,35102,586439,53800,907248,144845,596039,578102,895457,706928,220599,485341,46637,411055,884030,838537,461796,462519,514605,150839,400089,3173,847075,820298,244240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]