SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476529 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476529 [ RunTime:0.002318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275157,754914,794127,626415,880699,850517,718751,390103,822956,465203,680184,757805,776375,147781,103623,996142,846635,707169,768285,201370,877834,39651,376407,915823,191816,874879,82537,198451,26360,717861,180840,6216,392814,897279,962447,724992,67225,986258,933965,593835,935190,192193,381940,174586,983584,2242,777102,327593,462317,623516,76425,294240,254265,471046,94015,1030954,96637,612374,642476,521441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]