SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399648 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399648 [ RunTime:0.002379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536266,854662,843764,311980,924552,120322,129189,643084,413772,28306,668037,860166,740078,401579,780321,16279,739843,253651,767001,667688,709032,660282,461518,696852,440945,225366,253127,199085,290399,29992,294389,477998,275404,475589,140609,258813,944733,197035,227479,1014311,527406,483545,211607,698280,166895,465973,925519,59905,41614,447109,835750,70769,986222,497000,499157,942856,466521,949013,166663,686620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]