SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535541 LIMIT 1 [ RunTime:0.003266s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535541 [ RunTime:0.005361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511277,858826,271639,612779,450943,947297,399470,1009554,613957,802397,401526,517751,601014,207361,1008000,231292,431816,767664,207551,63815,621866,50063,304344,626495,857103,415429,811649,263544,260537,913665,785546,856199,539499,499323,923618,634074,498691,927927,329605,1014852,538397,482914,251418,460402,214471,975629,301985,866280,308699,572014,931572,87726,119262,744659,433534,992333,651275,462893,829403,446073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]