SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003728s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507416 LIMIT 1 [ RunTime:0.001062s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507416 [ RunTime:0.004301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596986,432242,1026229,106172,6381,782153,447202,705185,284673,1042022,631616,870650,279962,320687,804190,960710,990944,982104,841103,474241,67849,59082,915732,473953,405926,587973,90452,654488,721771,663923,155551,679714,655810,148530,986530,196953,243862,514559,976792,847936,1037666,394162,1026829,832305,641052,13074,369929,842400,848917,144651,424728,256320,589610,779833,359071,577689,1047568,465687,344708,20046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000369s ]