SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473462 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473462 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025036,318914,166105,355937,1004445,701856,242037,771138,161978,200948,980668,205005,782416,1008273,832775,180820,169757,701820,608565,240721,821305,311752,968593,1025890,810723,728067,207443,836279,586065,284326,619114,377491,138874,151835,351166,115448,490272,244825,110448,184588,954981,819148,730490,1028221,192820,626620,340872,575093,75678,670741,446528,479369,322488,270599,764573,503331,607019,600268,492262,219048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]