SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551011 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551011 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156012,251109,22873,207031,805067,915395,844322,956981,1006799,739269,236637,860358,987840,659095,591801,924219,511990,40285,282491,233134,729691,794068,648289,941190,197022,681092,787291,611398,721448,801043,764846,657577,635971,933070,403781,1012478,942424,686870,862240,799230,814145,112851,312832,386096,991212,334415,908905,154062,925856,293183,274707,596062,373939,298023,138312,89275,143994,971154,163333,1008531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]