SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020247 LIMIT 1 [ RunTime:0.001510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020247 [ RunTime:0.005107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518069,695523,192882,17239,930748,463389,340109,247379,343512,787568,122216,49365,608423,265412,838538,532003,11039,620510,529402,786274,461758,168551,599892,559342,44049,783434,617893,527005,456714,603668,563802,418797,870173,828669,273170,920130,35576,414174,92783,142160,310346,592646,263440,65147,747678,997376,181224,383118,635640,189798,390106,579574,986060,271044,537997,1004139,455888,360981,267515,44224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]