SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101211 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101211 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981143,949799,470323,704423,659093,97373,737918,761321,788744,1013007,396521,660554,277358,163493,452531,1008835,822159,27624,842288,767771,677705,332668,175325,314902,855527,191840,899217,242932,381561,377876,52863,746418,407071,97127,978639,951524,683723,1047143,512856,566846,105066,932078,37806,923335,1021303,422071,374969,681647,188449,636482,697369,759026,713868,704702,1030442,891152,942251,542257,608483,611523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]