SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345699 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345699 [ RunTime:0.003397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509516,879260,266775,263810,664836,352652,738797,136900,294473,304492,96940,140486,290170,781285,915458,488899,965925,464404,355199,81291,610920,217614,978231,1012538,637767,108758,226998,1025047,264380,499938,901291,276856,410207,195987,994240,248485,599198,635467,712402,969207,384536,916793,514414,784267,5971,997387,548543,932211,402658,132210,834218,178804,503891,722691,34119,953175,583766,656734,712424,274017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]