SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420214 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420214 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403556,746252,278751,206467,588946,455070,728182,385714,821590,310015,463145,728842,643153,105351,924058,524763,603997,102294,513067,587806,38066,23224,869251,223812,1010939,768577,170906,975970,191143,674421,994661,295766,212568,275780,905119,91248,714635,370580,59053,301348,220050,702450,65898,283201,502378,506605,300005,498785,7486,51787,228591,593625,741886,462557,599071,53833,598650,814748,487479,391911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]