SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544516 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544516 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535402,540440,287827,568026,105936,533064,236457,1014087,885690,624533,189370,909505,24219,644432,280358,126483,1004577,531769,781449,960805,637232,775485,881290,616192,422660,559313,46488,946008,1004593,629357,625376,751055,169713,360322,634909,1015151,46036,616290,963709,481479,611630,454404,545070,765984,236279,10483,882280,622972,1000416,239273,896374,271435,247803,426491,904470,544038,1026022,184451,921674,506543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]