SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045267 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045267 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58177,431230,458010,607435,159290,725256,378854,694480,468423,75978,615156,349085,489106,195064,985653,1006077,243402,330845,512579,888286,176796,860672,858697,696960,26932,489136,289224,586258,855321,1001288,909996,398670,730202,844602,777044,922087,717303,98394,143028,646628,553141,377318,517458,583749,511906,229444,183051,803686,79275,962656,1012608,70701,88827,691704,553326,731067,992719,474536,711678,776073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001767s ]