SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447496 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447496 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624924,377840,988286,197548,424420,646088,890281,340031,957110,199087,839833,833434,555934,477014,156233,451150,396476,877256,286108,221481,563666,416772,286949,24667,13484,374499,627117,196017,72487,658103,91226,841813,1012021,437014,473428,100601,586197,890179,929476,123563,477489,809305,11904,883913,298278,240617,603380,884733,487302,32848,843716,889850,968855,677026,757709,484069,508140,484049,915781,472942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]