SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 159501 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 159501 [ RunTime:0.001405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036478,183940,760369,741748,147817,353246,704646,825642,647264,831681,605409,404540,413572,534422,848276,178906,966982,924020,615228,107869,544997,394988,877382,120727,657258,722504,444098,197363,160409,614454,889652,872611,776144,230587,387011,731973,258508,739415,333879,1045393,71385,214959,148195,497152,38409,762128,924545,659895,169088,1046036,706683,126790,28144,233042,1041409,500119,581590,531792,143211,179514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 159501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 159501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]