SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534011 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534011 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551579,642489,816837,342452,651604,986315,263215,762779,8580,631611,353342,901957,421688,585746,1014628,779990,128894,781068,212223,146218,831157,482583,939568,239523,998894,668371,51986,648681,441032,238618,378526,361244,915680,949721,229726,1018676,387436,693882,546043,341527,488696,549146,956053,763021,818736,269507,320116,526394,835375,621407,589266,900531,376006,633887,631609,211037,185346,141240,635494,364420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]