SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510230 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510230 [ RunTime:0.002821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895384,517517,507319,393349,636646,33354,944632,548798,440750,481818,950165,987536,1011812,296933,335254,871243,200686,141943,93864,996644,795586,716589,567123,972512,247686,110837,896577,682715,243331,141635,767187,618096,764901,776410,177002,311592,17720,851307,791113,899914,194652,680506,78813,611067,687284,705326,206538,835771,787455,898688,49584,909809,817963,697146,984700,459541,1016198,1032196,297074,30543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002167s ]