SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502664 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502664 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561083,33827,702581,898905,356130,250988,806533,157824,133671,522731,617813,876279,956552,432059,546534,1013057,888562,518304,673210,989219,374752,1016148,65748,726381,135529,745593,789087,840550,178174,468123,730985,137654,320900,677321,548993,621518,119330,119176,619095,909006,646209,252445,1006140,227369,289486,426503,66975,778906,322275,144874,261345,650680,428988,775974,143381,536075,433056,914027,169651,842224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502664 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502664 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]