SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427814 LIMIT 1 [ RunTime:0.002012s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427814 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364260,151836,1025666,403398,954534,440665,209109,147926,556723,257919,897561,527168,797298,471683,199795,681921,338953,335209,592465,121558,511339,132179,407352,816045,187142,976162,693676,215962,784913,259719,597062,978004,718992,113269,890103,887474,412695,761324,80826,791577,925524,931386,309485,249906,66466,213568,86019,531801,198684,592676,940156,293679,169974,80447,323779,672268,1010085,895290,274452,437949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001234s ]