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` = 1016459 LIMIT 1 [ RunTime:0.001733s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016459 [ RunTime:0.007186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021042,870920,199353,611376,140483,35929,705450,512881,264437,506144,364842,127161,773142,892241,866442,956062,35624,174608,994743,812917,401393,299090,176496,135609,365638,121033,548063,584429,36670,688636,592726,929161,16749,909545,579908,605404,129980,626086,820763,170892,519858,594838,153091,651190,802492,677937,278113,81098,78126,954748,347803,104023,711593,222712,374514,848859,748310,911124,853409,686534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016459 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016459 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]