SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 621803 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 621803 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201496,466264,1029134,421589,446057,943717,69256,684745,496789,991240,980037,264202,736620,565854,921980,901070,626616,917243,358940,856463,300787,599222,668953,53291,676727,848619,405871,765547,302237,502416,690979,621543,351099,109031,146840,405775,769489,232520,430234,196583,598786,146861,609004,302018,557645,740182,474054,987502,658929,361351,620668,874089,293209,781894,200953,788307,1023197,657426,663236,447378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 621803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 621803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]