SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011249 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011249 [ RunTime:0.002703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552694,1043011,911805,588220,838026,156659,856602,977670,349404,639934,895940,480540,514162,989212,334161,222871,706130,266672,721004,841896,147670,568110,235067,622634,424927,605080,292078,361939,55875,509163,947228,799729,593611,671837,439853,701642,836796,362320,263400,569350,641389,568679,282635,955147,767975,702670,172806,1039262,982759,256784,448479,44687,593900,45607,803601,347180,449169,994913,623803,200483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]