SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414791 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414791 [ RunTime:0.003933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559767,561810,500836,246729,588500,649423,958948,626226,492476,578372,634735,503288,842523,535346,954123,494382,286545,401446,234912,777867,535774,882367,819621,727494,441718,257553,163241,61636,394329,198786,106618,603074,59342,519680,538075,257118,268714,326417,1020236,87933,355373,539881,737530,9942,495535,354321,892373,216989,322565,151828,34089,1009649,4648,1016266,914642,184809,373654,351622,333234,889609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]