SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378509 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378509 [ RunTime:0.002168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190521,198146,676646,904666,262314,134149,486636,104741,791313,46539,1034935,707735,140502,285440,429247,993486,1019783,679619,935476,259863,877272,308061,700827,573621,24368,287020,327797,1043976,325405,669067,769051,692824,125818,738185,103583,1011400,206145,1027417,504519,623041,613140,123318,770104,671732,90240,763434,1019990,869571,12039,392977,945887,37367,278302,967237,291192,514973,950165,1000174,874603,726381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]