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` = 345015 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345015 [ RunTime:0.003456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516452,183730,236630,919810,45416,780252,780617,109416,849897,345360,181273,737243,122444,769208,534360,264050,207481,849171,603110,557149,1010840,439506,95717,55333,827302,217067,479637,544251,154361,4214,587419,134194,293749,700573,133131,727388,547842,738587,1026245,562802,180567,534104,12097,718826,1020230,299544,833244,895808,692870,598894,691778,393998,958148,372420,155395,684310,656214,432518,768171,893091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000812s ]