SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514832 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514832 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619052,621506,201711,127832,240491,219841,593528,302004,1002852,256854,458279,24581,288047,888900,672462,229737,227292,356001,234391,767401,151720,467095,475268,532651,794753,737571,97875,8709,586577,840140,602104,126850,179609,604603,514460,551886,935752,338709,756091,956791,236839,852226,821709,891119,317771,109497,513389,906319,531168,985688,505452,740904,941919,737088,873239,992324,397167,702488,496062,325149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]