SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419561 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419561 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990139,1012733,392406,798458,695675,397547,707862,201267,529219,820127,712989,827199,978097,374820,349990,544725,13573,442365,901403,100510,130833,513560,881919,622381,509336,237682,397754,767164,8438,774946,202669,623895,498978,823151,100287,486455,476817,650184,864648,793547,194701,940294,836224,230148,589250,567144,746840,841980,873925,129611,459507,85542,345761,986812,342870,773726,344549,299727,141487,552029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]