SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504996 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504996 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913601,510042,614227,110901,435040,780024,727254,214812,803711,352239,708384,637976,250710,832847,57373,525568,273498,642145,816618,609774,312866,281777,454468,226555,251245,285377,748224,405466,192630,455828,296112,791354,898201,1012745,253984,311009,910338,3645,242632,167154,333540,169221,199638,349908,794073,245221,434432,361705,865443,567426,195638,983262,285666,194851,1015432,794270,19314,356506,521212,186226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]