SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501654 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501654 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77226,733483,682591,114391,350044,787713,770894,849160,642482,716527,670712,44363,162950,510688,697877,967606,459278,789473,667250,221386,977577,671798,98823,670805,69781,221624,748745,515686,748008,188961,332884,163193,44539,201243,434498,976896,698836,174003,477418,389680,627631,417131,29632,547379,276704,703001,36471,790379,759166,1047640,225677,1032973,121925,219897,111949,586390,900853,845490,161093,437067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]