SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 846887 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 846887 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101910,758015,541905,516983,367901,304919,493191,347644,356476,921186,702493,582513,291166,375112,211245,653569,675184,570093,48487,2112,296204,892314,443299,165590,387999,240855,912379,257414,514467,1031771,681796,298077,1046446,643268,60984,780361,504448,864295,380911,501524,207740,961825,441600,622325,363873,662912,919666,316749,982566,830489,430895,997966,510833,743149,85372,912006,793057,329792,56732,593542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 846887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 846887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]