SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001938s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469575 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469575 [ RunTime:0.005435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047853,447524,847883,439641,766843,206866,1005249,314634,719878,166537,991487,1010647,883482,497785,253014,672320,587986,984228,380682,300038,80162,690619,299077,522683,208433,75095,780128,423692,432086,71058,1028133,269403,701159,277804,17568,233265,373028,49746,937277,277562,436231,329013,908423,495462,710211,153521,908458,979997,1006671,696054,495995,963081,857141,226092,776083,290197,799716,302893,434325,516084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]