SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445538 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445538 [ RunTime:0.003418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249245,1031159,353401,15738,256080,679824,880136,997198,402115,222810,64755,896623,286776,997735,118541,355065,828613,468454,183400,852648,1030230,103001,814800,968276,575289,219789,694785,743090,878716,232564,697754,462119,481756,1025454,181266,76183,736824,747544,365838,228137,848224,188391,590877,544233,160706,449002,517602,92904,614105,709227,590230,929411,571099,104368,544947,712293,465715,182925,777342,381168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]