SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 897209 LIMIT 1 [ RunTime:0.001433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 897209 [ RunTime:0.004772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258969,31097,426722,1014550,1012114,161531,780496,1040696,265011,665050,118934,994343,304655,1005538,674902,156239,342458,848029,800052,15286,501218,579548,486643,497104,237061,971385,479044,486912,1048369,245520,806192,746658,528752,300417,288100,556114,7008,138933,766649,507920,702422,813883,602473,717621,909306,332554,821771,852420,280610,364055,641479,852480,781232,836632,984179,490294,811552,1017766,808346,14632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 897209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 897209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002200s ]