SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026047 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026047 [ RunTime:0.003150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455286,326968,927952,498756,229780,961206,939462,378114,986025,12715,1001263,78384,720833,427634,150282,79479,122380,944385,421159,13312,70865,378586,1042032,748937,539255,813209,406534,850686,778340,295726,746687,450110,920288,676483,223574,849122,52105,642658,888199,339075,493244,331330,4557,1011500,478346,93814,699258,492357,308011,721092,927412,213692,469578,704986,945382,754786,249018,1012894,579541,456670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]