SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504858 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504858 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620504,777285,343017,219852,602366,839175,908212,525029,326320,96938,54967,324591,168095,12174,463115,744870,152863,795664,968241,107005,934246,124217,651842,1026374,1008712,170829,399259,61936,751847,753001,979229,971459,660210,780207,309803,462957,920519,253172,469485,182194,718768,469398,778697,452838,319704,34732,1003605,102969,805362,596314,133986,375246,233863,865078,620668,555297,690548,788552,440759,438419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]