SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 944421 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 944421 [ RunTime:0.003186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492796,21827,278083,848025,662082,334448,1043295,407389,1028706,140677,152070,220412,703924,552307,1024178,575024,328783,176854,417616,631249,1039500,735684,222013,401162,347147,397283,339935,741243,366147,57314,311624,464401,990872,477122,811201,277097,497952,502116,142234,131697,122097,151925,241909,683317,272502,63133,3418,969670,336475,317207,564064,228062,98145,677586,630648,575911,54207,464807,168575,396471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 944421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 944421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002170s ]