SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002799s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681570 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681570 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509179,588065,314944,104214,85098,49791,914492,652494,988141,369291,482348,959750,766330,651989,788187,1039988,534436,248630,638211,814697,625725,813333,917980,35922,178683,848773,384485,972872,413316,302664,254848,274579,973699,771951,414875,829723,117378,1041151,958991,647790,338950,749826,276702,724036,578972,27795,549368,124225,896528,666452,927985,597265,1044332,666032,579252,608612,129030,558575,900879,503467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]