SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486313 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486313 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978556,325058,406750,779244,859946,148431,562163,66595,625878,635448,867649,632895,552937,1006784,956556,259689,404002,184583,498160,394921,221438,815925,850026,766270,318389,976565,217140,292014,361898,142954,94376,360545,553138,284103,903103,571902,85611,693385,648336,459878,241826,1001654,320363,522624,209779,709875,647545,609761,984875,199978,566756,618730,614126,835810,899259,1044654,546147,960053,590869,606311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]