SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416582 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416582 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983668,78732,896970,817278,47680,637731,251002,569061,871629,256943,135697,225864,196011,901118,575067,650165,193266,380759,661981,849154,721872,262303,519218,836183,442359,252578,450441,738008,134471,135151,849976,806875,89760,462212,654440,717665,499445,134053,246183,493150,335037,122970,414693,587908,53876,762671,632155,926832,972087,763002,867462,703512,38050,801259,555786,617980,592937,190110,417175,477483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]