SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59070 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59070 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670533,460988,792568,1023670,479473,238415,1042315,969869,328245,328448,596676,11353,401564,158571,122024,519523,336887,787433,112226,564825,20631,915428,85704,246566,1008239,265529,370809,301680,585218,277067,556804,748309,310191,682400,1021422,441847,622976,1016114,317864,899029,410297,442963,624902,973648,1024204,659081,349809,669880,301180,544258,734136,820823,373372,245125,117083,874159,482215,180326,939195,877412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]