SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014833 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014833 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906313,253525,682929,292483,769870,588162,1002340,118771,26272,703895,829020,265735,564570,971590,118781,270347,117142,808334,874177,77346,535925,453407,523249,580614,768090,821076,288751,186868,443765,108622,939631,419550,499718,60629,1033520,1025399,8968,688726,515610,43086,967191,703165,267024,599067,261945,150454,152298,889888,671920,697206,577977,21045,893451,213587,527787,768237,141474,396756,878378,734237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003257s ]