SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413714 LIMIT 1 [ RunTime:0.000709s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413714 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447312,881051,290701,353309,811829,778366,395064,1004749,152432,1025218,808695,830727,841937,367861,227718,595355,239718,874946,986579,54498,666588,776642,1040785,238794,723164,89529,864431,751443,729497,967833,903706,219311,115875,402872,438686,282589,228304,75668,289091,89748,217406,177609,955711,541187,719496,48219,1047645,165239,151026,423185,522381,964936,491948,685514,905510,417562,333834,536947,1023977,15739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]