SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98491 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98491 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812153,1023280,101716,821373,586606,965414,7290,565488,60353,949189,48626,392051,570741,331070,375985,482662,865295,96464,568774,89160,758693,909548,424565,203178,700011,17440,890965,520496,382914,1003041,697344,489225,627736,135809,828845,620605,923428,577481,294617,412491,1010747,987747,451820,3346,182805,749018,824554,388670,843574,31747,414929,474141,977554,266699,30913,182373,674580,59713,625845,340814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]