SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106714 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106714 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22751,107419,1011167,900743,874360,981049,820800,97246,137745,951220,571300,893827,870050,241519,489074,54897,183131,858420,186843,254785,989787,956518,438303,845731,931103,375669,57584,998942,817064,107542,508842,153881,387095,95866,26149,727808,1480,830598,326440,787983,76940,160010,235921,945428,575416,697392,198958,811796,382574,945520,13656,58211,606432,778799,752887,935453,844548,103634,556790,1036618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]