SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026447 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026447 [ RunTime:0.003726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467549,701379,183201,306694,863767,935639,334744,1018636,572822,279928,401317,446260,879409,883034,665848,971235,399292,90683,651782,204280,1024080,462188,59716,592844,236704,151557,942052,944794,32424,254455,183276,823425,304241,469142,576703,338558,664534,566448,714950,732276,951509,1015618,610614,1025982,877687,845349,412874,754126,957146,924648,401360,769867,841915,763765,709793,217798,271302,962710,799081,656514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000957s ]