SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198243 LIMIT 1 [ RunTime:0.001276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198243 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381507,903673,70528,37123,802183,741166,1020011,934037,876458,503199,674225,98887,236142,654102,687075,62659,96635,623668,74325,6249,79512,1028142,204663,815147,20824,161589,972624,254111,800517,313467,723412,649454,51341,996983,1006149,2904,354808,396287,377806,305149,973601,588153,953878,452216,985958,675933,581544,538462,408148,783546,236989,432921,682906,502093,726815,178499,94260,714600,769096,304089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]