SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406245 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406245 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658002,500703,517270,979247,719239,1023013,36675,833736,757611,270685,796258,493898,434660,496116,319362,1009540,720698,925216,381957,88288,961471,350236,780777,831623,286867,754769,890006,149483,253755,899699,22948,842115,680334,481911,310779,712080,233929,4371,352709,831312,48283,327736,414198,303057,306961,563273,904037,384874,173175,581813,591067,11612,124468,823613,902402,799552,621629,604278,866988,33843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]