SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408091 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408091 [ RunTime:0.002373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043687,876122,327402,970310,797121,853741,91444,410589,450947,661555,599060,897373,598199,216644,959673,563657,465619,38350,333173,675831,1021064,193349,339167,624357,995239,866658,607651,728885,305243,158199,770144,149430,343370,940682,300545,250197,577511,826468,552889,942776,734368,493236,757842,1006820,504963,94753,27981,1741,649285,308648,126669,1025247,174247,301976,730270,60624,572212,799851,936640,636012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]