SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402420 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402420 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235767,895037,320352,143538,938617,484188,11310,60592,328239,304242,139015,319830,108687,219157,246152,60488,223645,431663,349972,957595,443257,702460,276448,352261,515022,274704,693363,441593,1009624,454506,10023,489282,358173,657855,613524,552081,280051,597655,461774,462551,505003,80357,1018083,47270,304873,297546,974147,856555,907347,976089,556643,415051,459472,990493,455198,960880,764281,948889,944387,736783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]