SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424836 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424836 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019123,287976,766510,1012066,232276,665603,323146,736354,461314,783730,706111,322726,581025,98846,42802,102898,276676,891790,563485,515779,244598,333302,374971,316437,494533,26969,31772,926859,721010,652829,231051,98093,118767,1042498,369034,896718,137549,721386,603511,378405,626662,463569,104911,368355,45621,844825,554802,994269,421002,1036844,994407,641742,41894,340655,394492,89194,921567,461519,96437,49255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]