SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527513 LIMIT 1 [ RunTime:0.001554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527513 [ RunTime:0.004288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247876,531936,987213,512287,764313,805462,53166,263945,981167,705199,29028,702209,938274,582406,987811,99742,619524,114358,848193,47903,279785,30322,896397,793147,541538,501041,297084,934365,854435,105512,1009629,165270,95766,652336,263554,707940,139429,687633,871894,407848,924563,208214,830479,667537,220370,144097,653596,123540,169361,994497,874107,613695,390477,742292,666590,396239,222963,62058,756872,958596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]