SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047704 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047704 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279404,259968,488988,70257,886640,234742,565558,272701,401753,778404,860439,472432,224116,212347,275288,789904,958530,576017,365844,1044014,852716,516485,880083,139043,857835,598591,241020,423010,528343,570971,983435,136129,369431,229584,399945,789512,646732,318050,422669,1042374,157815,761893,44215,259382,119744,107983,850058,719043,608961,1014406,906476,347066,698792,397452,409824,885851,297619,292709,551296,533509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]