SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408620 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408620 [ RunTime:0.008099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308960,920406,508501,131000,371875,287528,354133,338514,630749,564636,235519,238700,289679,221177,865718,308183,1031007,932208,998882,858328,578338,506078,155288,359170,197621,102284,874625,257006,147771,130381,905090,444292,205929,417167,222611,1036262,873231,541305,944365,591181,947932,251346,553908,964706,289034,441421,1031210,316295,90156,555135,469391,971387,795771,603626,378694,41442,107254,599707,638364,321931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]