SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522266 LIMIT 1 [ RunTime:0.002736s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522266 [ RunTime:0.003172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313342,1027246,326737,174475,213410,1010345,401326,996006,129881,124128,24835,169714,935250,840963,998078,104553,540369,833859,543992,426352,337106,376722,433747,2669,601928,106259,904851,938181,415361,456381,680531,15298,167689,788798,194365,340487,968601,704552,111026,749967,703098,894394,189016,573320,863970,1006329,883022,876876,143272,200857,794316,69596,373170,122034,886804,458567,974716,888882,897968,174397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]