SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599845 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599845 [ RunTime:0.002907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699582,910704,245257,268845,459968,366296,13741,641011,533597,397571,119808,871328,696819,609796,339169,732727,205698,856389,502476,844280,75846,421932,179985,737051,574738,979506,769449,517553,884842,1017659,445086,240923,367328,275250,215581,477692,80326,403512,141804,938691,807854,422256,41252,963643,46840,960332,904261,373574,21237,677376,292292,578083,599577,984759,354528,1011531,965920,53688,164161,821139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]