SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449612 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449612 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805070,989599,767816,767462,716726,682170,630516,1036728,637992,4327,144427,239081,21395,882168,22991,910761,462648,278926,142030,862862,61281,397554,245947,1012028,948331,593894,827412,939718,820875,176930,685395,835627,856925,1014775,1021177,265551,157981,236785,226296,692314,207600,162510,56243,300064,602444,181593,809100,641215,762376,971983,597799,178973,346293,459692,658936,987401,760328,412060,965289,732433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]