SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101811 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101811 [ RunTime:0.002419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116194,1040584,1028373,1000482,506452,381003,442791,605345,325642,826763,756048,143990,201675,850093,323007,446675,150920,393645,787000,966624,604391,539149,841996,104749,77338,458562,889542,800197,418530,95102,183252,81569,532070,640590,565132,373241,280633,770315,165978,66583,1007613,500320,1032158,977270,260111,535447,299340,847587,1046800,934676,621417,50220,607355,306331,335004,578083,455793,23998,157005,447442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]