SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412302 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412302 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781866,666785,869426,604910,267712,1021385,311073,680378,251189,1048638,877418,228449,476097,414365,34804,847011,680602,3319,667850,439375,530340,104101,4317,764776,354806,261462,159072,1470,130535,918546,342018,348387,804809,476010,830688,282544,707189,507723,742802,641785,259328,906385,483920,955538,845613,23759,526592,429591,242145,891824,146180,263870,399583,611330,317517,854716,708840,724421,605166,922022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]