SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536499 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536499 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425557,813604,318315,204374,682496,463353,65486,55596,644010,662303,767888,676841,722242,303331,758242,187059,790350,914315,268004,959192,581044,200761,1006234,505911,780893,415771,281030,776197,969964,1020398,900433,949383,554292,115293,287979,187920,378068,454939,556384,798846,915723,1046557,472869,219104,227079,470021,628502,152156,1015531,681406,171396,101104,1004418,662168,270187,692379,787205,731094,573757,238755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]