SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002744s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174812 LIMIT 1 [ RunTime:0.004597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174812 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469011,643176,169304,110990,594590,444544,537126,840502,550202,569669,429771,322403,607698,32918,823524,542771,444852,127512,275030,335026,933084,196827,417803,743290,817640,431349,926031,332862,274877,73249,1002411,851749,825462,506294,396476,848844,316924,229643,1009971,469219,748040,318216,491175,721430,809026,636306,994040,957756,891912,309019,655291,342777,256734,794202,1036256,534413,649963,68685,267314,329130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]