SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244094 LIMIT 1 [ RunTime:0.004836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244094 [ RunTime:0.007158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015548,1028416,591570,448040,643723,807807,711450,969509,270109,40995,241869,36154,282043,493529,567394,644145,461611,675253,573457,1030855,634298,645401,628746,156021,3239,573090,993935,358586,736641,815254,501432,406992,632223,259860,379269,763587,22983,902097,226423,405197,857285,756029,367786,620979,728158,415638,855840,590302,40096,949309,768326,762193,485289,690285,378404,132190,595936,54911,934697,20682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]