SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043405 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043405 [ RunTime:0.002131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29700,779233,544218,501266,685366,112000,783762,105057,786003,566173,959058,82573,791626,458130,445928,200160,491749,128284,34753,505731,392851,835728,529352,854316,592573,608110,956720,345055,17529,635933,680465,733069,703799,183873,687273,877266,904901,866037,977311,828612,695675,779230,189716,841556,203823,403839,43137,603283,364800,125300,1012537,226635,930175,872328,959818,505442,973420,33454,340875,953487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001244s ]