SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263801 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263801 [ RunTime:0.003278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535961,141465,324555,189518,721482,31795,954846,433215,183669,724953,831009,771012,961087,811691,190436,1032305,318971,159032,527343,950328,7948,1005021,501949,523209,801047,208675,49349,544360,1022970,255778,594046,288338,453171,404492,637416,549985,855691,192492,298560,214607,189569,988230,628617,343050,140285,476222,260163,645090,818653,716470,169713,297437,539409,452686,355232,913277,201197,977317,1043632,813927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]