SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491094 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491094 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455386,22306,334421,144820,211026,64576,703101,1001045,774404,726024,719207,643549,32848,878575,86807,999575,209494,458334,568587,846180,575579,175039,240628,574246,667052,42380,968599,61427,953727,1006267,677605,569545,815512,830835,626416,927669,623428,164095,1016744,97040,620257,244405,815885,412024,868697,892845,376279,439280,978843,139392,396974,926864,639763,838148,889020,397182,79288,392816,666057,914468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]