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` = 431979 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431979 [ RunTime:0.002555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35379,558705,562799,119329,257771,121894,738173,145633,216479,524996,393834,45186,188130,180009,934281,438468,1013076,343051,229060,66668,82567,265372,395180,316418,841916,157862,915599,613280,194427,450035,576834,829173,589992,290924,440796,716193,221208,865583,95123,1044490,1013483,166136,940204,833414,958214,549990,577149,372386,646717,353459,982126,47261,777565,756628,522266,483094,153233,804249,101012,232583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]