SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449580 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449580 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83500,463258,142753,246314,110790,304180,659283,291495,789391,673284,277075,76509,172683,20558,1042033,259322,937687,26501,46688,139754,276490,438719,251398,363259,148100,496869,408740,461880,1024042,199516,175037,305171,4065,196375,168329,424523,586942,980587,608291,222756,888708,635989,13500,765279,601883,118283,271333,756951,224116,297458,720486,256269,746384,307802,136277,915559,171452,822944,393127,383357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]