SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440433 LIMIT 1 [ RunTime:0.000908s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440433 [ RunTime:0.002796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742805,1011693,1019099,64645,947421,665489,183998,837709,1023839,659003,24499,578935,689164,706982,325320,416338,572942,818241,6,659239,599102,713187,300036,15916,546001,844209,615240,283335,245229,103573,197633,943050,876025,454721,280431,466416,82532,185681,834293,75006,647026,492183,188672,408491,945733,718311,261199,261431,383494,18434,281677,158005,160628,711931,46829,734110,183026,975919,349616,72000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001550s ]