SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385689 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385689 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78345,4437,1035346,751174,43249,1007745,334487,521218,427140,360259,480554,501626,278560,191301,84812,954239,199376,643316,719710,1033166,716368,984020,988243,58208,1037696,140538,644537,654390,447092,181918,45998,330479,43902,718683,243320,480542,764643,920739,794068,934664,714840,282919,36988,162812,817199,287801,217690,749633,377354,203347,920840,100586,169515,1020487,578454,426832,495605,679644,362524,605875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]