SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418036 LIMIT 1 [ RunTime:0.000609s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418036 [ RunTime:0.003105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658960,367048,32197,1020413,420719,834268,242270,254685,939652,304167,392748,982376,565455,53631,679210,710741,618368,811072,554186,1023228,804782,22560,625019,995813,314061,55704,480256,374590,150682,470161,70853,290465,822587,140618,609276,898777,1047780,625118,508951,770806,875168,155762,727534,319617,862903,557967,423494,191088,661212,499408,383864,654317,1028574,54451,294567,772293,956688,832336,931447,110304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]